J. Craig Williams — Smartsheet Community

Skip to content

Overview

Overview
Email	jcwill23@gmail.com
Roles	Member
Badges	35

About Me

About Me
Area of Expertise
About Me	Smartsheet Certified User <br /><br />See:<br />https://ronin-global.com/contact-us-smartsheet-help/<br />to see info about me or how to contact me.<br />The password is "thankyou"<br /><br />Also I have posted tips and tricks for Smartsheet here:<br />https://ronin-global.com/category/smartsheet-help/
How I Use Smartsheet	Daily tasks, any around the house or longer than a few days projects, project management, resource management.
Linkedin	http://www.linkedin.com/in/jcwill23
Twitter Page

Analytics

4,105

Posts

53

Visits

23.8k

Points

Nov 21, 2015

Join Date

Feb 21, 2025

Last Active

Re: Formula to assign fiscal quarter not working

J. Craig Williams

08/08/18

Here's a shorter version: =IFERROR("Q" + VALUE(IF(MONTH([Estimated Ship]@row) <= 6, 2, -2) + INT((MONTH([Estimated Ship Date]@row) + 2) / 3)), "") Craig

1 ·
Re: Default properties for rows

J. Craig Williams

09/29/18

I believe this is a bug. The columns are 'remembering' the formatting from the original template. I don't know how or why, but early-on found a work-around so stopped investigating. No amount of savi…

1 ·
Re: Totaling a column with check boxes

J. Craig Williams

04/01/17

One clarification to Shaine's point. You CAN put the calculation into the CheckBox column, but the result must be converted to text by adding + "" to it. If the count or sum then needs to b…

1 ·
Re: Percentage (%) complete formula

J. Craig Williams

08/09/18

=MIN( your formula, 1) Watch out for divide by zero when the task is completed the same day it started. Craig

1 ·
Re: COUNTIF USING OR

J. Craig Williams

04/18/18

Responding to Josh: Your syntax is wrong. Your use of the [Type] column implies you are looking for something there (car, wagon, etc...) but you aren't. I fixed the formula on your sheet: =COUNTIF(Co…

3 ·